using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.Sql;
using sgsBase;
 
namespace gaClear
{
[Serializable] public class DbVwTradeSummary :  DbViewObject
{
  public DbVwTradeSummary() : base()
  {
      Table = "dbo.vwTradeSummary";
      Database = "gagm_energy";
      Columns.AddColumn("RefId", SqlDbType.Int);
      Columns.AddColumn("TradeTypeId", SqlDbType.Int);
      Columns.AddColumn("TTCategoryId", SqlDbType.Int);
      Columns.AddColumn("TVTDesc", SqlDbType.NVarChar);
      Columns.AddColumn("TrDateTime", SqlDbType.DateTime);
      Columns.AddColumn("TrPStart", SqlDbType.DateTime);
      Columns.AddColumn("TrPEnd", SqlDbType.DateTime);
      Columns.AddColumn("TrStrikePrice", SqlDbType.Float);
      Columns.AddColumn("TrPricePremium", SqlDbType.Float);
      Columns.AddColumn("TTDesc", SqlDbType.NVarChar);
      Columns.AddColumn("TTLongDesc", SqlDbType.NVarChar);
      Columns.AddColumn("TTAbbrDesc", SqlDbType.NVarChar);
      Columns.AddColumn("FlUserId", SqlDbType.Int);
      Columns.AddColumn("ShortName", SqlDbType.NVarChar);
      Columns.AddColumn("FullName", SqlDbType.NVarChar);
      Columns.AddColumn("TtlAmount", SqlDbType.Float);
      Columns.AddColumn("TrBCommPct", SqlDbType.Float);
      Columns.AddColumn("TrSCommPct", SqlDbType.Float);
      Columns.AddColumn("TtlBCommission", SqlDbType.Real);
      Columns.AddColumn("TtlSCommission", SqlDbType.Real);
      Columns.AddColumn("TtlBCoCommission", SqlDbType.Real);
      Columns.AddColumn("TtlSCoCommission", SqlDbType.Real);
      Columns.AddColumn("TrBCompanyId", SqlDbType.Int);
      Columns.AddColumn("TrBCoName", SqlDbType.NVarChar);
      Columns.AddColumn("TrBCoAbbrName", SqlDbType.NVarChar);
      Columns.AddColumn("BCatAbbr", SqlDbType.VarChar);
      Columns.AddColumn("TrBTraderId", SqlDbType.Int);
      Columns.AddColumn("TrBTrader", SqlDbType.NVarChar);
      Columns.AddColumn("TrBBrokerId", SqlDbType.Int);
      Columns.AddColumn("TrBBroker", SqlDbType.NVarChar);
      Columns.AddColumn("TrBCommission", SqlDbType.Float);
      Columns.AddColumn("TrSCompanyId", SqlDbType.Int);
      Columns.AddColumn("TrSCoName", SqlDbType.NVarChar);
      Columns.AddColumn("TrSCoAbbrName", SqlDbType.NVarChar);
      Columns.AddColumn("SCatAbbr", SqlDbType.VarChar);
      Columns.AddColumn("TrSTraderId", SqlDbType.Int);
      Columns.AddColumn("TrSTrader", SqlDbType.NVarChar);
      Columns.AddColumn("TrSBrokerId", SqlDbType.Int);
      Columns.AddColumn("TrSBroker", SqlDbType.NVarChar);
      Columns.AddColumn("TrSCommission", SqlDbType.Float);
      Columns.AddColumn("TrVolume", SqlDbType.Float);
      Columns.AddColumn("TradeVolFreqId", SqlDbType.Int);
      Columns.AddColumn("TVFSeqNo", SqlDbType.Int);
      Columns.AddColumn("TVFDesc", SqlDbType.NVarChar);
      Columns.AddColumn("Units", SqlDbType.NVarChar);
      Columns.AddColumn("FinalUnits", SqlDbType.NVarChar);
      Columns.AddColumn("Multiple", SqlDbType.Int);
      Columns.AddColumn("TVFLongDesc", SqlDbType.NVarChar);
      Columns.AddColumn("TVLTtlFormula", SqlDbType.NVarChar);
      Columns.AddColumn("FlLastUpdate", SqlDbType.DateTime);
      Columns.AddColumn("FlCurrNodeId", SqlDbType.Int);
      Columns.AddColumn("FlCurrStatus", SqlDbType.Int);
      Columns.AddColumn("CurrStatus", SqlDbType.VarChar);
      Columns.AddColumn("LkAdditional", SqlDbType.VarChar);
      Columns.AddColumn("TrAdditional", SqlDbType.NVarChar);
      Columns.AddColumn("BuyerForm", SqlDbType.NVarChar);
      Columns.AddColumn("SellerForm", SqlDbType.NVarChar);
      Columns.AddColumn("FlNotes", SqlDbType.NVarChar);
      Columns.AddColumn("Revised", SqlDbType.Int);
      Columns.AddColumn("TtlAdditionalAmount", SqlDbType.Real);
      Columns.AddColumn("ClearedBy", SqlDbType.Int);
      Columns.AddColumn("ClearedByCo", SqlDbType.VarChar);
      Columns.AddColumn("ClearedByDesc", SqlDbType.VarChar);
      Columns.AddColumn("TrABrokerId", SqlDbType.Int);
      Columns.AddColumn("TrABroker", SqlDbType.NVarChar);
      Columns.AddColumn("TrACommPct", SqlDbType.Float);
      Columns.AddColumn("TtlACommission", SqlDbType.Real);
      Columns.AddColumn("ExtField", SqlDbType.NVarChar);
      Columns.AddColumn("BCoClearId", SqlDbType.VarChar);
      Columns.AddColumn("SCoClearId", SqlDbType.VarChar);
      Columns.AddColumn("BBlockCounterparty", SqlDbType.Int);
      Columns.AddColumn("SBlockCounterparty", SqlDbType.Int);
      Columns.AddColumn("MonthlyVol", SqlDbType.Float);
  }
  
  #region Properties
  
      public int RefId
      {
          get { return Columns.IntAt(0);}
          set { Columns.SetValAt(0, value);}
      }

      public int TradeTypeId
      {
          get { return Columns.IntAt(1);}
          set { Columns.SetValAt(1, value);}
      }

      public int TTCategoryId
      {
          get { return Columns.IntAt(2);}
          set { Columns.SetValAt(2, value);}
      }

      public String TVTDesc
      {
          get { return Columns.StringAt(3);}
          set { Columns.SetValAt(3, value);}
      }

      public DateTime TrDateTime
      {
          get { return Columns.DateTimeTSAt(4);}
          set { Columns.SetValAt(4, value, true);}
      }

      public DateTime TrPStart
      {
          get { return Columns.DateTimeTSAt(5);}
          set { Columns.SetValAt(5, value, true);}
      }

      public DateTime TrPEnd
      {
          get { return Columns.DateTimeTSAt(6);}
          set { Columns.SetValAt(6, value, true);}
      }

      public double TrStrikePrice
      {
          get { return Columns.DoubleAt(7);}
          set { Columns.SetValAt(7, value);}
      }

      public double TrPricePremium
      {
          get { return Columns.DoubleAt(8);}
          set { Columns.SetValAt(8, value);}
      }

      public String TTDesc
      {
          get { return Columns.StringAt(9);}
          set { Columns.SetValAt(9, value);}
      }

      public String TTLongDesc
      {
          get { return Columns.StringAt(10);}
          set { Columns.SetValAt(10, value);}
      }

      public String TTAbbrDesc
      {
          get { return Columns.StringAt(11);}
          set { Columns.SetValAt(11, value);}
      }

      public int FlUserId
      {
          get { return Columns.IntAt(12);}
          set { Columns.SetValAt(12, value);}
      }

      public String ShortName
      {
          get { return Columns.StringAt(13);}
          set { Columns.SetValAt(13, value);}
      }

      public String FullName
      {
          get { return Columns.StringAt(14);}
          set { Columns.SetValAt(14, value);}
      }

      public double TtlAmount
      {
          get { return Columns.DoubleAt(15);}
          set { Columns.SetValAt(15, value);}
      }

      public double TrBCommPct
      {
          get { return Columns.DoubleAt(16);}
          set { Columns.SetValAt(16, value);}
      }

      public double TrSCommPct
      {
          get { return Columns.DoubleAt(17);}
          set { Columns.SetValAt(17, value);}
      }

      public double TtlBCommission
      {
          get { return Columns.DoubleAt(18);}
          set { Columns.SetValAt(18, value);}
      }

      public double TtlSCommission
      {
          get { return Columns.DoubleAt(19);}
          set { Columns.SetValAt(19, value);}
      }

      public double TtlBCoCommission
      {
          get { return Columns.DoubleAt(20);}
          set { Columns.SetValAt(20, value);}
      }

      public double TtlSCoCommission
      {
          get { return Columns.DoubleAt(21);}
          set { Columns.SetValAt(21, value);}
      }

      public int TrBCompanyId
      {
          get { return Columns.IntAt(22);}
          set { Columns.SetValAt(22, value);}
      }

      public String TrBCoName
      {
          get { return Columns.StringAt(23);}
          set { Columns.SetValAt(23, value);}
      }

      public String TrBCoAbbrName
      {
          get { return Columns.StringAt(24);}
          set { Columns.SetValAt(24, value);}
      }

      public String BCatAbbr
      {
          get { return Columns.StringAt(25);}
          set { Columns.SetValAt(25, value);}
      }

      public int TrBTraderId
      {
          get { return Columns.IntAt(26);}
          set { Columns.SetValAt(26, value);}
      }

      public String TrBTrader
      {
          get { return Columns.StringAt(27);}
          set { Columns.SetValAt(27, value);}
      }

      public int TrBBrokerId
      {
          get { return Columns.IntAt(28);}
          set { Columns.SetValAt(28, value);}
      }

      public String TrBBroker
      {
          get { return Columns.StringAt(29);}
          set { Columns.SetValAt(29, value);}
      }

      public double TrBCommission
      {
          get { return Columns.DoubleAt(30);}
          set { Columns.SetValAt(30, value);}
      }

      public int TrSCompanyId
      {
          get { return Columns.IntAt(31);}
          set { Columns.SetValAt(31, value);}
      }

      public String TrSCoName
      {
          get { return Columns.StringAt(32);}
          set { Columns.SetValAt(32, value);}
      }

      public String TrSCoAbbrName
      {
          get { return Columns.StringAt(33);}
          set { Columns.SetValAt(33, value);}
      }

      public String SCatAbbr
      {
          get { return Columns.StringAt(34);}
          set { Columns.SetValAt(34, value);}
      }

      public int TrSTraderId
      {
          get { return Columns.IntAt(35);}
          set { Columns.SetValAt(35, value);}
      }

      public String TrSTrader
      {
          get { return Columns.StringAt(36);}
          set { Columns.SetValAt(36, value);}
      }

      public int TrSBrokerId
      {
          get { return Columns.IntAt(37);}
          set { Columns.SetValAt(37, value);}
      }

      public String TrSBroker
      {
          get { return Columns.StringAt(38);}
          set { Columns.SetValAt(38, value);}
      }

      public double TrSCommission
      {
          get { return Columns.DoubleAt(39);}
          set { Columns.SetValAt(39, value);}
      }

      public double TrVolume
      {
          get { return Columns.DoubleAt(40);}
          set { Columns.SetValAt(40, value);}
      }

      public int TradeVolFreqId
      {
          get { return Columns.IntAt(41);}
          set { Columns.SetValAt(41, value);}
      }

      public int TVFSeqNo
      {
          get { return Columns.IntAt(42);}
          set { Columns.SetValAt(42, value);}
      }

      public String TVFDesc
      {
          get { return Columns.StringAt(43);}
          set { Columns.SetValAt(43, value);}
      }

      public String Units
      {
          get { return Columns.StringAt(44);}
          set { Columns.SetValAt(44, value);}
      }

      public String FinalUnits
      {
          get { return Columns.StringAt(45);}
          set { Columns.SetValAt(45, value);}
      }

      public int Multiple
      {
          get { return Columns.IntAt(46);}
          set { Columns.SetValAt(46, value);}
      }

      public String TVFLongDesc
      {
          get { return Columns.StringAt(47);}
          set { Columns.SetValAt(47, value);}
      }

      public String TVLTtlFormula
      {
          get { return Columns.StringAt(48);}
          set { Columns.SetValAt(48, value);}
      }

      public DateTime FlLastUpdate
      {
          get { return Columns.DateTimeTSAt(49);}
          set { Columns.SetValAt(49, value, true);}
      }

      public int FlCurrNodeId
      {
          get { return Columns.IntAt(50);}
          set { Columns.SetValAt(50, value);}
      }

      public int FlCurrStatus
      {
          get { return Columns.IntAt(51);}
          set { Columns.SetValAt(51, value);}
      }

      public String CurrStatus
      {
          get { return Columns.StringAt(52);}
          set { Columns.SetValAt(52, value);}
      }

      public String LkAdditional
      {
          get { return Columns.StringAt(53);}
          set { Columns.SetValAt(53, value);}
      }

      public String TrAdditional
      {
          get { return Columns.StringAt(54);}
          set { Columns.SetValAt(54, value);}
      }

      public String BuyerForm
      {
          get { return Columns.StringAt(55);}
          set { Columns.SetValAt(55, value);}
      }

      public String SellerForm
      {
          get { return Columns.StringAt(56);}
          set { Columns.SetValAt(56, value);}
      }

      public String FlNotes
      {
          get { return Columns.StringAt(57);}
          set { Columns.SetValAt(57, value);}
      }

      public int Revised
      {
          get { return Columns.IntAt(58);}
          set { Columns.SetValAt(58, value);}
      }

      public double TtlAdditionalAmount
      {
          get { return Columns.DoubleAt(59);}
          set { Columns.SetValAt(59, value);}
      }

      public int ClearedBy
      {
          get { return Columns.IntAt(60);}
          set { Columns.SetValAt(60, value);}
      }

      public String ClearedByCo
      {
          get { return Columns.StringAt(61);}
          set { Columns.SetValAt(61, value);}
      }

      public String ClearedByDesc
      {
          get { return Columns.StringAt(62);}
          set { Columns.SetValAt(62, value);}
      }

      public int TrABrokerId
      {
          get { return Columns.IntAt(63);}
          set { Columns.SetValAt(63, value);}
      }

      public String TrABroker
      {
          get { return Columns.StringAt(64);}
          set { Columns.SetValAt(64, value);}
      }

      public double TrACommPct
      {
          get { return Columns.DoubleAt(65);}
          set { Columns.SetValAt(65, value);}
      }

      public double TtlACommission
      {
          get { return Columns.DoubleAt(66);}
          set { Columns.SetValAt(66, value);}
      }

      public String ExtField
      {
          get { return Columns.StringAt(67);}
          set { Columns.SetValAt(67, value);}
      }

      public String BCoClearId
      {
          get { return Columns.StringAt(68);}
          set { Columns.SetValAt(68, value);}
      }

      public String SCoClearId
      {
          get { return Columns.StringAt(69);}
          set { Columns.SetValAt(69, value);}
      }

      public int BBlockCounterparty
      {
          get { return Columns.IntAt(70);}
          set { Columns.SetValAt(70, value);}
      }

      public int SBlockCounterparty
      {
          get { return Columns.IntAt(71);}
          set { Columns.SetValAt(71, value);}
      }

      public double MonthlyVol
      {
          get { return Columns.DoubleAt(72);}
          set { Columns.SetValAt(72, value);}
      }

  
  #endregion
}
}
